package com.stars.module.setting.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.stars.module.setting.entity.SystemDefine;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author : Rocks
 * @version : 1.0
 * @date : 2023/1/30 23:05
 * @description : 系统设置数据库映射
 */
@Mapper
public interface SystemDefineMapper extends BaseMapper<SystemDefine> {

    @Select("SELECT MAX(SHOWORDER) FROM STAR_SYSTEM_DEFINE")
    Integer getMaxIndex();

    @Delete("DELETE FROM STAR_SYSTEM_DEFINE WHERE ID = #{id}")
    Boolean deleteDefineById (String id);

}
